<?php
namespace app\index\controller;
use think\Controller;
use think\Db;
// use think\Route;
// 注册路由到index模块的News控制器的read操作
// Route::rule('sum','index/Index/sumlist','get');
class Index extends Controller
{
    public function index()
    {
        $a= date('Y');
        dump($a);
        exit;
        return '<style type="text/css">*{ padding: 0; margin: 0; } .think_default_text{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:)</h1><p> ThinkPHP V5<br/><span style="font-size:30px">十年磨一剑 - 为API开发设计的高性能框架</span></p><span style="font-size:22px;">[ V5.0 版本由 <a href="http://www.qiniu.com" target="qiniu">七牛云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="https://tajs.qq.com/stats?sId=9347272" charset="UTF-8"></script><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="ad_bd568ce7058a1091"></think>';
    }

    public function add($name,$money,$who){
        
        $data=[
            'name'=>$name,
            'money'=>$money,
            'who'=>$who,
            'status'=>0,
            'time'=>date('Y-m-d H:i:s'),
        ];
        
        if(Db::name('apply')->insert($data)){
            return json(['code'=>1]);
        }
        else{
            return json(['code'=>0]); 
        }
    
    }
    
    
    
    
    public function dd($id){
        
        $data=[
            
            'status'=>1,
        ];
        
        if(Db::name('apply')->where('id',$id)->update($data)){
            return json(['code'=>1]);
        }
        else{
            return json(['code'=>0]); 
        }
    
    }
    
    

    public function month1($month)
    {
        $y= date('Y');
        $a=["$y-$month-1", "$y-$month-31"];
        $data=Db::table('apply')->whereTime('time', 'between', $a)->order('id desc')->select();
        if($data==null){
            return json(['code'=>0,'msg'=>'没有数据','data'=>$data]);
        }
        else{
            return json(['code'=>1,'msg'=>'ok','data'=>$data]); 
        }
    }

    
    public function sum()
    {
        
        $data1=Db::table('apply')->whereTime('time', 'today')->where('status',0)->sum('money');
        $data2=Db::table('apply')->whereTime('time', 'week')->where('status',0)->sum('money');
        $data3=Db::table('apply')->whereTime('time', 'month')->where('status',0)->sum('money');
        $data4=Db::table('apply')->whereTime('time', 'month')->where('who',1)->where('status',0)->sum('money');
        $data5=Db::table('apply')->whereTime('time', 'month')->where('who',2)->where('status',0)->sum('money');
        // dump($data1);
        // dump($data2);
        // dump($data3);
        // dump($data4);
        // dump($data5);
        // exit;
        // if($data1==null){
            return json(['code'=>0,'today'=>$data1,'week'=>$data2,'month'=>$data3,'tch'=>$data4,'lyj'=>$data5]);
        // }
        // else{
        //     return json(['code'=>1,'msg'=>'ok','data'=>$data]); 
        // }
    }
}
